Algorithms for Answering Queries Eeciently Using Views

نویسنده

  • Prasenjit Mitra
چکیده

Algorithms for answering queries using views have been used to integrate information from multiple sources. The bucket algorithm, predominantly used to reformulate queries, has two drawbacks. It generates a large number of candidate solutions, even when the number of sound solutions is small, and then checks for their soundness using an exponential conjunctive-query-containment test. Leser 1] presents an algorithm that generates a smaller number of candidate solutions and also eliminates the conjunctive-query-containment-test, but does not guarantee the soundness of all generated solutions. We introduce the concept of shared variable buckets(SVB) covering all subgoals that share a variable in order to ensure that only sound solutions are generated and thus avoid the conjunctive-query containment test. The algorithm presented has the advantage that it avoids generation of a large set of candidate solutions whenever possible. Experimental results prove the superiority of this algorithm over previous solutions.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

بهبود الگوریتم انتخاب دید در پایگاه داده‌‌ تحلیلی با استفاده از یافتن پرس‌ وجوهای پرتکرار

A data warehouse is a source for storing historical data to support decision making. Usually analytic queries take much time. To solve response time problem it should be materialized some views to answer all queries in minimum response time. There are many solutions for view selection problems. The most appropriate solution for view selection is materializing frequent queries. Previously posed ...

متن کامل

Answering Regular Path Queries Using Views

Query answering using views amounts to computing the answer to a query having information only on the extension of a set of views. This problem is relevant in several fields, such as information integration, data warehousing, query optimization, mobile computing, and maintaining physical data independence. We address query answering using views in a context where queries and views are regular p...

متن کامل

Answering Queries Using Views in the Presence of Functional Dependencies

This paper is concerned with the problem of answering queries using views in the presence of functional dependencies. Previous algorithms for answering queries using views, such as the MiniCon algorithm, have not taken into account the presence of functional dependencies. As a consequence, these algorithms may miss query rewritings in the presence of such dependencies. In this paper, we present...

متن کامل

Answering Queries Using Views: A Survey

The problem of answering queries using views is to find efficient methods of answering a query using a set of previously materialized views over the database, rather than accessing the database relations. The problem has recently received significant attention because of its relevance to a wide variety of data management problems. In query optimization, finding a rewriting of a query using a se...

متن کامل

An algorithm for answering queries efficiently using views

Algorithms for answering queries using views have been used in query planning to answer queries posed to knowledge bases, databases, and information systems. However, these algorithms do not scale well when the number of views increases. Three known algorithms, the bucket algorithm, the inverse-rules algorithm and an algorithm suggested by Leser have been used to reformulate queries before gene...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2001